import pandas as pd
import numpy as np
from openpyxl import load_workbook

INPUT_PATH = 'runs\\20251004-074338\\input.xlsx'

df = pd.read_excel(INPUT_PATH, sheet_name='退货明细')

result_df = df.copy()
result_df['Amount'] = result_df['Amount'].round(2)

with pd.ExcelWriter(INPUT_PATH, engine='openpyxl', mode='a', if_sheet_exists='replace') as writer:
    result_df.to_excel(writer, sheet_name='Result', index=False)

print("DONE: Processed 60 return records with amounts rounded to 2 decimals")